﻿--Default Values

SET QUOTED_IDENTIFIER ON;
GO
SET ANSI_NULLS ON;
GO

-- Insert External Order
INSERT INTO ExternalOrderSet(Unit, Price, CreationDate, HarvestDate, WantedQuantity, ProvidedQuantity, AmapExternalOrderId, ProductId, AmapId, RemainedQuantity)
	VALUES('kg', 0.8, GETDATE(), GETDATE(), 100, -1, 3, (select top 1 Id from ProductSet where name = 'Champignons de paris'), 2, -1)

-- Insert External Request
INSERT INTO RequestSet(WantedQuantity, ProvidedQuantity, AmapId, OfferId)
	VALUEs(50,50,2,1)
INSERT INTO RequestSet(WantedQuantity, ProvidedQuantity, AmapId, OfferId)
	VALUEs(75,75,2,3)

-- Insert Basket
INSERT INTO BasketSet(Price, Week, Year)
	VALUES(8.50, 51, 2012)